set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[a_Article_RSS_allsite]
AS
set nocount on
declare @str varchar(1000)

Select CatID, uName from a_CatMain where CatID in (
	select distinct MainCatID  
	from a_Articles where PublishStatus = 1 and Permission = 0 and MainCatID is not null
)


